Dataset statistics
| Number of variables | 31 |
|---|---|
| Number of observations | 563777 |
| Missing cells | 3006921 |
| Missing cells (%) | 17.2% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 133.3 MiB |
| Average record size in memory | 248.0 B |
Variable types
| Numeric | 20 |
|---|---|
| DateTime | 1 |
| Categorical | 4 |
| Text | 6 |
CANCELLED is highly imbalanced (98.4%) | Imbalance |
DIVERTED is highly imbalanced (98.9%) | Imbalance |
CANCELLATION_CODE has 562958 (99.9%) missing values | Missing |
CARRIER_DELAY has 487430 (86.5%) missing values | Missing |
WEATHER_DELAY has 487430 (86.5%) missing values | Missing |
NAS_DELAY has 487430 (86.5%) missing values | Missing |
SECURITY_DELAY has 487430 (86.5%) missing values | Missing |
LATE_AIRCRAFT_DELAY has 487430 (86.5%) missing values | Missing |
WEATHER_DELAY is highly skewed (γ1 = 26.30717485) | Skewed |
SECURITY_DELAY is highly skewed (γ1 = 28.01922379) | Skewed |
DEP_DELAY has 27141 (4.8%) zeros | Zeros |
ARR_DELAY has 10405 (1.8%) zeros | Zeros |
CARRIER_DELAY has 31823 (5.6%) zeros | Zeros |
WEATHER_DELAY has 73995 (13.1%) zeros | Zeros |
NAS_DELAY has 38489 (6.8%) zeros | Zeros |
SECURITY_DELAY has 75722 (13.4%) zeros | Zeros |
LATE_AIRCRAFT_DELAY has 40437 (7.2%) zeros | Zeros |
Reproduction
| Analysis started | 2024-03-30 05:46:04.796411 |
|---|---|
| Analysis finished | 2024-03-30 05:48:41.158276 |
| Duration | 2 minutes and 36.36 seconds |
| Software version | ydata-profiling vv4.7.0 |
| Download configuration | config.json |
DAY_OF_WEEK
Real number (ℝ)
| Distinct | 7 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3.9520058 |
| Minimum | 1 |
|---|---|
| Maximum | 7 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.3 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 2 |
| median | 4 |
| Q3 | 6 |
| 95-th percentile | 7 |
| Maximum | 7 |
| Range | 6 |
| Interquartile range (IQR) | 4 |
Descriptive statistics
| Standard deviation | 1.9647226 |
|---|---|
| Coefficient of variation (CV) | 0.49714567 |
| Kurtosis | -1.1716324 |
| Mean | 3.9520058 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | 0.05944324 |
| Sum | 2228050 |
| Variance | 3.8601348 |
| Monotonicity | Increasing |
Histogram with fixed size bins (bins=7)
| Value | Count | Frequency (%) |
| 3 | 93769 | |
| 4 | 90051 | |
| 1 | 79441 | |
| 7 | 79255 | |
| 5 | 76509 | |
| 2 | 74686 | |
| 6 | 70066 |
| Value | Count | Frequency (%) |
| 1 | 79441 | |
| 2 | 74686 | |
| 3 | 93769 | |
| 4 | 90051 | |
| 5 | 76509 | |
| 6 | 70066 | |
| 7 | 79255 |
| Value | Count | Frequency (%) |
| 7 | 79255 | |
| 6 | 70066 | |
| 5 | 76509 | |
| 4 | 90051 | |
| 3 | 93769 | |
| 2 | 74686 | |
| 1 | 79441 |
FL_DATE
Date
| Distinct | 30 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.3 MiB |
| Minimum | 2023-11-01 00:00:00 |
|---|---|
| Maximum | 2023-11-30 00:00:00 |
Histogram with fixed size bins (bins=30)
OP_UNIQUE_CARRIER
Categorical
| Distinct | 15 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.3 MiB |
| WN | |
|---|---|
| DL | |
| AA | |
| UA | |
| OO | |
| Other values (10) |
Length
| Max length | 2 |
|---|---|
| Median length | 2 |
| Mean length | 2 |
| Min length | 2 |
Characters and Unicode
| Total characters | 1127554 |
|---|---|
| Distinct characters | 21 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 9E |
|---|---|
| 2nd row | 9E |
| 3rd row | 9E |
| 4th row | 9E |
| 5th row | 9E |
Common Values
| Value | Count | Frequency (%) |
| WN | 122501 | |
| DL | 80353 | |
| AA | 76407 | |
| UA | 57897 | |
| OO | 57194 | |
| NK | 23164 | 4.1% |
| YX | 22002 | 3.9% |
| B6 | 21281 | 3.8% |
| MQ | 19729 | 3.5% |
| AS | 19255 | 3.4% |
| Other values (5) | 63994 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| wn | 122501 | |
| dl | 80353 | |
| aa | 76407 | |
| ua | 57897 | |
| oo | 57194 | |
| nk | 23164 | 4.1% |
| yx | 22002 | 3.9% |
| b6 | 21281 | 3.8% |
| mq | 19729 | 3.5% |
| as | 19255 | 3.4% |
| Other values (5) | 63994 |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 236587 | |
| N | 145665 | |
| O | 130538 | |
| W | 122501 | |
| D | 80353 | 7.1% |
| L | 80353 | 7.1% |
| U | 57897 | 5.1% |
| 9 | 32283 | 2.9% |
| K | 23164 | 2.1% |
| H | 22771 | 2.0% |
| Other values (11) | 195442 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1127554 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| A | 236587 | |
| N | 145665 | |
| O | 130538 | |
| W | 122501 | |
| D | 80353 | 7.1% |
| L | 80353 | 7.1% |
| U | 57897 | 5.1% |
| 9 | 32283 | 2.9% |
| K | 23164 | 2.1% |
| H | 22771 | 2.0% |
| Other values (11) | 195442 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1127554 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| A | 236587 | |
| N | 145665 | |
| O | 130538 | |
| W | 122501 | |
| D | 80353 | 7.1% |
| L | 80353 | 7.1% |
| U | 57897 | 5.1% |
| 9 | 32283 | 2.9% |
| K | 23164 | 2.1% |
| H | 22771 | 2.0% |
| Other values (11) | 195442 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1127554 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| A | 236587 | |
| N | 145665 | |
| O | 130538 | |
| W | 122501 | |
| D | 80353 | 7.1% |
| L | 80353 | 7.1% |
| U | 57897 | 5.1% |
| 9 | 32283 | 2.9% |
| K | 23164 | 2.1% |
| H | 22771 | 2.0% |
| Other values (11) | 195442 |
OP_CARRIER_FL_NUM
Real number (ℝ)
| Distinct | 5923 |
|---|---|
| Distinct (%) | 1.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2292.2298 |
| Minimum | 1 |
|---|---|
| Maximum | 8817 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.3 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 286 |
| Q1 | 1044 |
| median | 2047 |
| Q3 | 3339 |
| 95-th percentile | 5371 |
| Maximum | 8817 |
| Range | 8816 |
| Interquartile range (IQR) | 2295 |
Descriptive statistics
| Standard deviation | 1560.0442 |
|---|---|
| Coefficient of variation (CV) | 0.68057932 |
| Kurtosis | -0.55960755 |
| Mean | 2292.2298 |
| Median Absolute Deviation (MAD) | 1097 |
| Skewness | 0.61927368 |
| Sum | 1.2923064 × 109 |
| Variance | 2433737.9 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 540 | 323 | 0.1% |
| 323 | 313 | 0.1% |
| 759 | 291 | 0.1% |
| 1173 | 289 | 0.1% |
| 648 | 289 | 0.1% |
| 706 | 288 | 0.1% |
| 649 | 288 | 0.1% |
| 533 | 285 | 0.1% |
| 519 | 283 | 0.1% |
| 1515 | 280 | < 0.1% |
| Other values (5913) | 560848 |
| Value | Count | Frequency (%) |
| 1 | 169 | |
| 2 | 118 | |
| 3 | 106 | |
| 4 | 146 | |
| 5 | 145 | |
| 6 | 85 | |
| 7 | 118 | |
| 8 | 154 | |
| 9 | 150 | |
| 10 | 116 |
| Value | Count | Frequency (%) |
| 8817 | 1 | |
| 8815 | 1 | |
| 8814 | 1 | |
| 8810 | 1 | |
| 8809 | 1 | |
| 8800 | 1 | |
| 8790 | 2 | |
| 8788 | 1 | |
| 8786 | 1 | |
| 8785 | 2 |
ORIGIN_AIRPORT_ID
Real number (ℝ)
| Distinct | 332 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 12648.151 |
| Minimum | 10135 |
|---|---|
| Maximum | 16869 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.3 MiB |
Quantile statistics
| Minimum | 10135 |
|---|---|
| 5-th percentile | 10397 |
| Q1 | 11292 |
| median | 12889 |
| Q3 | 14027 |
| 95-th percentile | 14893 |
| Maximum | 16869 |
| Range | 6734 |
| Interquartile range (IQR) | 2735 |
Descriptive statistics
| Standard deviation | 1529.3126 |
|---|---|
| Coefficient of variation (CV) | 0.12091195 |
| Kurtosis | -1.3005151 |
| Mean | 12648.151 |
| Median Absolute Deviation (MAD) | 1591 |
| Skewness | 0.10941036 |
| Sum | 7.1307364 × 109 |
| Variance | 2338797.1 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 10397 | 27473 | 4.9% |
| 11298 | 24070 | 4.3% |
| 11292 | 23934 | 4.2% |
| 13930 | 20354 | 3.6% |
| 11057 | 16708 | 3.0% |
| 12889 | 16234 | 2.9% |
| 14107 | 15792 | 2.8% |
| 12892 | 15742 | 2.8% |
| 13204 | 14325 | 2.5% |
| 12953 | 13264 | 2.4% |
| Other values (322) | 375881 |
| Value | Count | Frequency (%) |
| 10135 | 374 | 0.1% |
| 10136 | 141 | < 0.1% |
| 10140 | 2005 | |
| 10141 | 59 | < 0.1% |
| 10146 | 60 | < 0.1% |
| 10155 | 87 | < 0.1% |
| 10157 | 149 | < 0.1% |
| 10158 | 325 | 0.1% |
| 10165 | 9 | < 0.1% |
| 10170 | 57 | < 0.1% |
| Value | Count | Frequency (%) |
| 16869 | 136 | < 0.1% |
| 16218 | 144 | < 0.1% |
| 15991 | 58 | < 0.1% |
| 15919 | 986 | |
| 15841 | 58 | < 0.1% |
| 15624 | 642 | |
| 15607 | 60 | < 0.1% |
| 15582 | 51 | < 0.1% |
| 15569 | 51 | < 0.1% |
| 15412 | 1155 |
ORIGIN
Text
| Distinct | 332 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.3 MiB |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 1691331 |
|---|---|
| Distinct characters | 26 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | LGA |
|---|---|
| 2nd row | LGA |
| 3rd row | TYS |
| 4th row | LGA |
| 5th row | JFK |
| Value | Count | Frequency (%) |
| atl | 27473 | 4.9% |
| dfw | 24070 | 4.3% |
| den | 23934 | 4.2% |
| ord | 20354 | 3.6% |
| clt | 16708 | 3.0% |
| las | 16234 | 2.9% |
| phx | 15792 | 2.8% |
| lax | 15742 | 2.8% |
| mco | 14325 | 2.5% |
| lga | 13264 | 2.4% |
| Other values (322) | 375881 |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 192700 | 11.4% |
| L | 157359 | 9.3% |
| S | 144538 | 8.5% |
| D | 131421 | 7.8% |
| T | 90221 | 5.3% |
| O | 85956 | 5.1% |
| C | 85401 | 5.0% |
| M | 76276 | 4.5% |
| F | 70495 | 4.2% |
| W | 66380 | 3.9% |
| Other values (16) | 590584 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1691331 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| A | 192700 | 11.4% |
| L | 157359 | 9.3% |
| S | 144538 | 8.5% |
| D | 131421 | 7.8% |
| T | 90221 | 5.3% |
| O | 85956 | 5.1% |
| C | 85401 | 5.0% |
| M | 76276 | 4.5% |
| F | 70495 | 4.2% |
| W | 66380 | 3.9% |
| Other values (16) | 590584 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1691331 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| A | 192700 | 11.4% |
| L | 157359 | 9.3% |
| S | 144538 | 8.5% |
| D | 131421 | 7.8% |
| T | 90221 | 5.3% |
| O | 85956 | 5.1% |
| C | 85401 | 5.0% |
| M | 76276 | 4.5% |
| F | 70495 | 4.2% |
| W | 66380 | 3.9% |
| Other values (16) | 590584 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1691331 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| A | 192700 | 11.4% |
| L | 157359 | 9.3% |
| S | 144538 | 8.5% |
| D | 131421 | 7.8% |
| T | 90221 | 5.3% |
| O | 85956 | 5.1% |
| C | 85401 | 5.0% |
| M | 76276 | 4.5% |
| F | 70495 | 4.2% |
| W | 66380 | 3.9% |
| Other values (16) | 590584 |
ORIGIN_CITY_NAME
Text
| Distinct | 326 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.3 MiB |
Length
| Max length | 34 |
|---|---|
| Median length | 29 |
| Mean length | 13.065255 |
| Min length | 8 |
Characters and Unicode
| Total characters | 7365890 |
|---|---|
| Distinct characters | 56 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | New York, NY |
|---|---|
| 2nd row | New York, NY |
| 3rd row | Knoxville, TN |
| 4th row | New York, NY |
| 5th row | New York, NY |
| Value | Count | Frequency (%) |
| ca | 61128 | 4.6% |
| tx | 60554 | 4.6% |
| fl | 52257 | 4.0% |
| ny | 30488 | 2.3% |
| san | 29549 | 2.2% |
| ga | 29397 | 2.2% |
| il | 28118 | 2.1% |
| new | 27955 | 2.1% |
| atlanta | 27473 | 2.1% |
| chicago | 27099 | 2.1% |
| Other values (396) | 941286 |
Most occurring characters
| Value | Count | Frequency (%) |
| 751527 | 10.2% | |
| , | 563777 | 7.7% |
| a | 563069 | 7.6% |
| o | 406070 | 5.5% |
| e | 389239 | 5.3% |
| n | 360089 | 4.9% |
| t | 351439 | 4.8% |
| l | 326681 | 4.4% |
| i | 279504 | 3.8% |
| r | 268245 | 3.6% |
| Other values (46) | 3106250 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 7365890 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 751527 | 10.2% | |
| , | 563777 | 7.7% |
| a | 563069 | 7.6% |
| o | 406070 | 5.5% |
| e | 389239 | 5.3% |
| n | 360089 | 4.9% |
| t | 351439 | 4.8% |
| l | 326681 | 4.4% |
| i | 279504 | 3.8% |
| r | 268245 | 3.6% |
| Other values (46) | 3106250 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 7365890 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 751527 | 10.2% | |
| , | 563777 | 7.7% |
| a | 563069 | 7.6% |
| o | 406070 | 5.5% |
| e | 389239 | 5.3% |
| n | 360089 | 4.9% |
| t | 351439 | 4.8% |
| l | 326681 | 4.4% |
| i | 279504 | 3.8% |
| r | 268245 | 3.6% |
| Other values (46) | 3106250 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 7365890 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 751527 | 10.2% | |
| , | 563777 | 7.7% |
| a | 563069 | 7.6% |
| o | 406070 | 5.5% |
| e | 389239 | 5.3% |
| n | 360089 | 4.9% |
| t | 351439 | 4.8% |
| l | 326681 | 4.4% |
| i | 279504 | 3.8% |
| r | 268245 | 3.6% |
| Other values (46) | 3106250 |
ORIGIN_STATE_NM
Text
| Distinct | 52 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.3 MiB |
Length
| Max length | 46 |
|---|---|
| Median length | 14 |
| Mean length | 8.1394771 |
| Min length | 4 |
Characters and Unicode
| Total characters | 4588850 |
|---|---|
| Distinct characters | 47 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | New York |
|---|---|
| 2nd row | New York |
| 3rd row | Tennessee |
| 4th row | New York |
| 5th row | New York |
| Value | Count | Frequency (%) |
| california | 61128 | 9.5% |
| texas | 60554 | 9.4% |
| florida | 52257 | 8.1% |
| new | 44463 | 6.9% |
| york | 30488 | 4.7% |
| georgia | 29397 | 4.6% |
| carolina | 29304 | 4.5% |
| illinois | 28118 | 4.4% |
| colorado | 26031 | 4.0% |
| north | 25938 | 4.0% |
| Other values (51) | 257822 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 619650 | |
| i | 515146 | 11.2% |
| o | 441621 | 9.6% |
| n | 337058 | 7.3% |
| r | 336909 | 7.3% |
| e | 280895 | 6.1% |
| s | 258441 | 5.6% |
| l | 255059 | 5.6% |
| C | 118137 | 2.6% |
| d | 114157 | 2.5% |
| Other values (37) | 1311777 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 4588850 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 619650 | |
| i | 515146 | 11.2% |
| o | 441621 | 9.6% |
| n | 337058 | 7.3% |
| r | 336909 | 7.3% |
| e | 280895 | 6.1% |
| s | 258441 | 5.6% |
| l | 255059 | 5.6% |
| C | 118137 | 2.6% |
| d | 114157 | 2.5% |
| Other values (37) | 1311777 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 4588850 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 619650 | |
| i | 515146 | 11.2% |
| o | 441621 | 9.6% |
| n | 337058 | 7.3% |
| r | 336909 | 7.3% |
| e | 280895 | 6.1% |
| s | 258441 | 5.6% |
| l | 255059 | 5.6% |
| C | 118137 | 2.6% |
| d | 114157 | 2.5% |
| Other values (37) | 1311777 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 4588850 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 619650 | |
| i | 515146 | 11.2% |
| o | 441621 | 9.6% |
| n | 337058 | 7.3% |
| r | 336909 | 7.3% |
| e | 280895 | 6.1% |
| s | 258441 | 5.6% |
| l | 255059 | 5.6% |
| C | 118137 | 2.6% |
| d | 114157 | 2.5% |
| Other values (37) | 1311777 |
ORIGIN_WAC
Real number (ℝ)
| Distinct | 52 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 54.814159 |
| Minimum | 1 |
|---|---|
| Maximum | 93 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.3 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 13 |
| Q1 | 34 |
| median | 45 |
| Q3 | 82 |
| 95-th percentile | 91 |
| Maximum | 93 |
| Range | 92 |
| Interquartile range (IQR) | 48 |
Descriptive statistics
| Standard deviation | 26.643041 |
|---|---|
| Coefficient of variation (CV) | 0.48606129 |
| Kurtosis | -1.3228245 |
| Mean | 54.814159 |
| Median Absolute Deviation (MAD) | 23 |
| Skewness | -0.032845138 |
| Sum | 30902962 |
| Variance | 709.85162 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 91 | 61128 | 10.8% |
| 74 | 60554 | 10.7% |
| 33 | 52257 | 9.3% |
| 22 | 30488 | 5.4% |
| 34 | 29397 | 5.2% |
| 41 | 28118 | 5.0% |
| 82 | 26031 | 4.6% |
| 36 | 24558 | 4.4% |
| 38 | 18747 | 3.3% |
| 81 | 18080 | 3.2% |
| Other values (42) | 214419 |
| Value | Count | Frequency (%) |
| 1 | 2441 | 0.4% |
| 2 | 10584 | |
| 3 | 2923 | 0.5% |
| 4 | 456 | 0.1% |
| 5 | 99 | < 0.1% |
| 11 | 1674 | 0.3% |
| 12 | 990 | 0.2% |
| 13 | 11240 | |
| 14 | 505 | 0.1% |
| 15 | 1050 | 0.2% |
| Value | Count | Frequency (%) |
| 93 | 15315 | 2.7% |
| 92 | 6423 | 1.1% |
| 91 | 61128 | |
| 88 | 542 | 0.1% |
| 87 | 9412 | 1.7% |
| 86 | 2193 | 0.4% |
| 85 | 17843 | 3.2% |
| 84 | 1640 | 0.3% |
| 83 | 2347 | 0.4% |
| 82 | 26031 |
DEST_AIRPORT_ID
Real number (ℝ)
| Distinct | 332 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 12648.242 |
| Minimum | 10135 |
|---|---|
| Maximum | 16869 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.3 MiB |
Quantile statistics
| Minimum | 10135 |
|---|---|
| 5-th percentile | 10397 |
| Q1 | 11292 |
| median | 12889 |
| Q3 | 14027 |
| 95-th percentile | 14893 |
| Maximum | 16869 |
| Range | 6734 |
| Interquartile range (IQR) | 2735 |
Descriptive statistics
| Standard deviation | 1529.2571 |
|---|---|
| Coefficient of variation (CV) | 0.12090669 |
| Kurtosis | -1.3004231 |
| Mean | 12648.242 |
| Median Absolute Deviation (MAD) | 1591 |
| Skewness | 0.10937815 |
| Sum | 7.1307877 × 109 |
| Variance | 2338627.2 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 10397 | 27466 | 4.9% |
| 11298 | 24071 | 4.3% |
| 11292 | 23939 | 4.2% |
| 13930 | 20352 | 3.6% |
| 11057 | 16705 | 3.0% |
| 12889 | 16237 | 2.9% |
| 14107 | 15803 | 2.8% |
| 12892 | 15744 | 2.8% |
| 13204 | 14333 | 2.5% |
| 12953 | 13268 | 2.4% |
| Other values (322) | 375859 |
| Value | Count | Frequency (%) |
| 10135 | 374 | 0.1% |
| 10136 | 141 | < 0.1% |
| 10140 | 2005 | |
| 10141 | 59 | < 0.1% |
| 10146 | 60 | < 0.1% |
| 10155 | 87 | < 0.1% |
| 10157 | 149 | < 0.1% |
| 10158 | 324 | 0.1% |
| 10165 | 9 | < 0.1% |
| 10170 | 57 | < 0.1% |
| Value | Count | Frequency (%) |
| 16869 | 136 | < 0.1% |
| 16218 | 144 | < 0.1% |
| 15991 | 58 | < 0.1% |
| 15919 | 986 | |
| 15841 | 58 | < 0.1% |
| 15624 | 642 | |
| 15607 | 60 | < 0.1% |
| 15582 | 51 | < 0.1% |
| 15569 | 51 | < 0.1% |
| 15412 | 1154 |
DEST
Text
| Distinct | 332 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.3 MiB |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 1691331 |
|---|---|
| Distinct characters | 26 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | STL |
|---|---|
| 2nd row | SYR |
| 3rd row | LGA |
| 4th row | TYS |
| 5th row | ORF |
| Value | Count | Frequency (%) |
| atl | 27466 | 4.9% |
| dfw | 24071 | 4.3% |
| den | 23939 | 4.2% |
| ord | 20352 | 3.6% |
| clt | 16705 | 3.0% |
| las | 16237 | 2.9% |
| phx | 15803 | 2.8% |
| lax | 15744 | 2.8% |
| mco | 14333 | 2.5% |
| lga | 13268 | 2.4% |
| Other values (322) | 375859 |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 192698 | 11.4% |
| L | 157357 | 9.3% |
| S | 144524 | 8.5% |
| D | 131418 | 7.8% |
| T | 90204 | 5.3% |
| O | 85956 | 5.1% |
| C | 85402 | 5.0% |
| M | 76276 | 4.5% |
| F | 70498 | 4.2% |
| W | 66386 | 3.9% |
| Other values (16) | 590612 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1691331 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| A | 192698 | 11.4% |
| L | 157357 | 9.3% |
| S | 144524 | 8.5% |
| D | 131418 | 7.8% |
| T | 90204 | 5.3% |
| O | 85956 | 5.1% |
| C | 85402 | 5.0% |
| M | 76276 | 4.5% |
| F | 70498 | 4.2% |
| W | 66386 | 3.9% |
| Other values (16) | 590612 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1691331 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| A | 192698 | 11.4% |
| L | 157357 | 9.3% |
| S | 144524 | 8.5% |
| D | 131418 | 7.8% |
| T | 90204 | 5.3% |
| O | 85956 | 5.1% |
| C | 85402 | 5.0% |
| M | 76276 | 4.5% |
| F | 70498 | 4.2% |
| W | 66386 | 3.9% |
| Other values (16) | 590612 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1691331 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| A | 192698 | 11.4% |
| L | 157357 | 9.3% |
| S | 144524 | 8.5% |
| D | 131418 | 7.8% |
| T | 90204 | 5.3% |
| O | 85956 | 5.1% |
| C | 85402 | 5.0% |
| M | 76276 | 4.5% |
| F | 70498 | 4.2% |
| W | 66386 | 3.9% |
| Other values (16) | 590612 |
DEST_CITY_NAME
Text
| Distinct | 326 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.3 MiB |
Length
| Max length | 34 |
|---|---|
| Median length | 29 |
| Mean length | 13.06512 |
| Min length | 8 |
Characters and Unicode
| Total characters | 7365814 |
|---|---|
| Distinct characters | 56 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | St. Louis, MO |
|---|---|
| 2nd row | Syracuse, NY |
| 3rd row | New York, NY |
| 4th row | Knoxville, TN |
| 5th row | Norfolk, VA |
| Value | Count | Frequency (%) |
| ca | 61126 | 4.6% |
| tx | 60564 | 4.6% |
| fl | 52286 | 4.0% |
| ny | 30494 | 2.3% |
| san | 29561 | 2.2% |
| ga | 29387 | 2.2% |
| il | 28116 | 2.1% |
| new | 27962 | 2.1% |
| atlanta | 27466 | 2.1% |
| chicago | 27098 | 2.1% |
| Other values (396) | 941281 |
Most occurring characters
| Value | Count | Frequency (%) |
| 751564 | 10.2% | |
| , | 563777 | 7.7% |
| a | 563060 | 7.6% |
| o | 406074 | 5.5% |
| e | 389229 | 5.3% |
| n | 360067 | 4.9% |
| t | 351380 | 4.8% |
| l | 326632 | 4.4% |
| i | 279468 | 3.8% |
| r | 268261 | 3.6% |
| Other values (46) | 3106302 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 7365814 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 751564 | 10.2% | |
| , | 563777 | 7.7% |
| a | 563060 | 7.6% |
| o | 406074 | 5.5% |
| e | 389229 | 5.3% |
| n | 360067 | 4.9% |
| t | 351380 | 4.8% |
| l | 326632 | 4.4% |
| i | 279468 | 3.8% |
| r | 268261 | 3.6% |
| Other values (46) | 3106302 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 7365814 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 751564 | 10.2% | |
| , | 563777 | 7.7% |
| a | 563060 | 7.6% |
| o | 406074 | 5.5% |
| e | 389229 | 5.3% |
| n | 360067 | 4.9% |
| t | 351380 | 4.8% |
| l | 326632 | 4.4% |
| i | 279468 | 3.8% |
| r | 268261 | 3.6% |
| Other values (46) | 3106302 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 7365814 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 751564 | 10.2% | |
| , | 563777 | 7.7% |
| a | 563060 | 7.6% |
| o | 406074 | 5.5% |
| e | 389229 | 5.3% |
| n | 360067 | 4.9% |
| t | 351380 | 4.8% |
| l | 326632 | 4.4% |
| i | 279468 | 3.8% |
| r | 268261 | 3.6% |
| Other values (46) | 3106302 |
DEST_STATE_NM
Text
| Distinct | 52 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.3 MiB |
Length
| Max length | 46 |
|---|---|
| Median length | 14 |
| Mean length | 8.139165 |
| Min length | 4 |
Characters and Unicode
| Total characters | 4588674 |
|---|---|
| Distinct characters | 47 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Missouri |
|---|---|
| 2nd row | New York |
| 3rd row | New York |
| 4th row | Tennessee |
| 5th row | Virginia |
| Value | Count | Frequency (%) |
| california | 61126 | 9.5% |
| texas | 60564 | 9.4% |
| florida | 52286 | 8.1% |
| new | 44469 | 6.9% |
| york | 30494 | 4.7% |
| georgia | 29387 | 4.6% |
| carolina | 29293 | 4.5% |
| illinois | 28116 | 4.4% |
| colorado | 26036 | 4.0% |
| north | 25928 | 4.0% |
| Other values (51) | 257802 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 619634 | |
| i | 515141 | 11.2% |
| o | 441630 | 9.6% |
| n | 336979 | 7.3% |
| r | 336923 | 7.3% |
| e | 280857 | 6.1% |
| s | 258402 | 5.6% |
| l | 255067 | 5.6% |
| C | 118131 | 2.6% |
| d | 114188 | 2.5% |
| Other values (37) | 1311722 |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 4588674 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| a | 619634 | |
| i | 515141 | 11.2% |
| o | 441630 | 9.6% |
| n | 336979 | 7.3% |
| r | 336923 | 7.3% |
| e | 280857 | 6.1% |
| s | 258402 | 5.6% |
| l | 255067 | 5.6% |
| C | 118131 | 2.6% |
| d | 114188 | 2.5% |
| Other values (37) | 1311722 |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 4588674 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| a | 619634 | |
| i | 515141 | 11.2% |
| o | 441630 | 9.6% |
| n | 336979 | 7.3% |
| r | 336923 | 7.3% |
| e | 280857 | 6.1% |
| s | 258402 | 5.6% |
| l | 255067 | 5.6% |
| C | 118131 | 2.6% |
| d | 114188 | 2.5% |
| Other values (37) | 1311722 |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 4588674 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| a | 619634 | |
| i | 515141 | 11.2% |
| o | 441630 | 9.6% |
| n | 336979 | 7.3% |
| r | 336923 | 7.3% |
| e | 280857 | 6.1% |
| s | 258402 | 5.6% |
| l | 255067 | 5.6% |
| C | 118131 | 2.6% |
| d | 114188 | 2.5% |
| Other values (37) | 1311722 |
DEST_WAC
Real number (ℝ)
| Distinct | 52 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 54.813401 |
| Minimum | 1 |
|---|---|
| Maximum | 93 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.3 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 13 |
| Q1 | 34 |
| median | 45 |
| Q3 | 82 |
| 95-th percentile | 91 |
| Maximum | 93 |
| Range | 92 |
| Interquartile range (IQR) | 48 |
Descriptive statistics
| Standard deviation | 26.643483 |
|---|---|
| Coefficient of variation (CV) | 0.48607608 |
| Kurtosis | -1.3228185 |
| Mean | 54.813401 |
| Median Absolute Deviation (MAD) | 23 |
| Skewness | -0.032891431 |
| Sum | 30902535 |
| Variance | 709.8752 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 91 | 61126 | 10.8% |
| 74 | 60564 | 10.7% |
| 33 | 52286 | 9.3% |
| 22 | 30494 | 5.4% |
| 34 | 29387 | 5.2% |
| 41 | 28116 | 5.0% |
| 82 | 26036 | 4.6% |
| 36 | 24548 | 4.4% |
| 38 | 18747 | 3.3% |
| 81 | 18089 | 3.2% |
| Other values (42) | 214384 |
| Value | Count | Frequency (%) |
| 1 | 2440 | 0.4% |
| 2 | 10588 | |
| 3 | 2929 | 0.5% |
| 4 | 456 | 0.1% |
| 5 | 99 | < 0.1% |
| 11 | 1676 | 0.3% |
| 12 | 988 | 0.2% |
| 13 | 11237 | |
| 14 | 502 | 0.1% |
| 15 | 1050 | 0.2% |
| Value | Count | Frequency (%) |
| 93 | 15305 | 2.7% |
| 92 | 6420 | 1.1% |
| 91 | 61126 | |
| 88 | 542 | 0.1% |
| 87 | 9416 | 1.7% |
| 86 | 2193 | 0.4% |
| 85 | 17844 | 3.2% |
| 84 | 1640 | 0.3% |
| 83 | 2343 | 0.4% |
| 82 | 26036 |
CRS_DEP_TIME
Real number (ℝ)
| Distinct | 1263 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1326.6317 |
| Minimum | 1 |
|---|---|
| Maximum | 2359 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.3 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 600 |
| Q1 | 905 |
| median | 1320 |
| Q3 | 1738 |
| 95-th percentile | 2128 |
| Maximum | 2359 |
| Range | 2358 |
| Interquartile range (IQR) | 833 |
Descriptive statistics
| Standard deviation | 495.54703 |
|---|---|
| Coefficient of variation (CV) | 0.37353776 |
| Kurtosis | -1.0671185 |
| Mean | 1326.6317 |
| Median Absolute Deviation (MAD) | 415 |
| Skewness | 0.083275995 |
| Sum | 7.4792444 × 108 |
| Variance | 245566.86 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 600 | 12135 | 2.2% |
| 700 | 9558 | 1.7% |
| 800 | 5929 | 1.1% |
| 900 | 3692 | 0.7% |
| 630 | 3597 | 0.6% |
| 730 | 3539 | 0.6% |
| 1000 | 3521 | 0.6% |
| 830 | 3207 | 0.6% |
| 615 | 3005 | 0.5% |
| 1100 | 2906 | 0.5% |
| Other values (1253) | 512688 |
| Value | Count | Frequency (%) |
| 1 | 2 | < 0.1% |
| 2 | 2 | < 0.1% |
| 3 | 1 | < 0.1% |
| 4 | 7 | < 0.1% |
| 5 | 4 | < 0.1% |
| 6 | 3 | < 0.1% |
| 7 | 5 | < 0.1% |
| 8 | 28 | |
| 9 | 20 | |
| 10 | 11 | < 0.1% |
| Value | Count | Frequency (%) |
| 2359 | 1029 | |
| 2358 | 42 | < 0.1% |
| 2357 | 29 | < 0.1% |
| 2356 | 89 | < 0.1% |
| 2355 | 168 | < 0.1% |
| 2354 | 51 | < 0.1% |
| 2353 | 7 | < 0.1% |
| 2352 | 38 | < 0.1% |
| 2351 | 43 | < 0.1% |
| 2350 | 138 | < 0.1% |
DEP_TIME
Real number (ℝ)
| Distinct | 1420 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 770 |
| Missing (%) | 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1326.3436 |
| Minimum | 1 |
|---|---|
| Maximum | 2400 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.3 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 557 |
| Q1 | 906 |
| median | 1322 |
| Q3 | 1742 |
| 95-th percentile | 2133 |
| Maximum | 2400 |
| Range | 2399 |
| Interquartile range (IQR) | 836 |
Descriptive statistics
| Standard deviation | 504.75178 |
|---|---|
| Coefficient of variation (CV) | 0.38055884 |
| Kurtosis | -1.0249768 |
| Mean | 1326.3436 |
| Median Absolute Deviation (MAD) | 418 |
| Skewness | 0.046381843 |
| Sum | 7.4674072 × 108 |
| Variance | 254774.36 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 555 | 1543 | 0.3% |
| 557 | 1439 | 0.3% |
| 556 | 1372 | 0.2% |
| 558 | 1321 | 0.2% |
| 554 | 1279 | 0.2% |
| 655 | 1270 | 0.2% |
| 559 | 1200 | 0.2% |
| 656 | 1168 | 0.2% |
| 658 | 1162 | 0.2% |
| 654 | 1154 | 0.2% |
| Other values (1410) | 550099 |
| Value | Count | Frequency (%) |
| 1 | 59 | |
| 2 | 51 | |
| 3 | 37 | |
| 4 | 55 | |
| 5 | 59 | |
| 6 | 39 | |
| 7 | 53 | |
| 8 | 49 | |
| 9 | 43 | |
| 10 | 40 |
| Value | Count | Frequency (%) |
| 2400 | 45 | < 0.1% |
| 2359 | 71 | |
| 2358 | 83 | |
| 2357 | 77 | |
| 2356 | 109 | |
| 2355 | 115 | |
| 2354 | 124 | |
| 2353 | 108 | |
| 2352 | 118 | |
| 2351 | 96 |
DEP_DELAY
Real number (ℝ)
ZEROS
| Distinct | 955 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 776 |
| Missing (%) | 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5.8737231 |
| Minimum | -72 |
|---|---|
| Maximum | 3518 |
| Zeros | 27141 |
| Zeros (%) | 4.8% |
| Negative | 364200 |
| Negative (%) | 64.6% |
| Memory size | 4.3 MiB |
Quantile statistics
| Minimum | -72 |
|---|---|
| 5-th percentile | -10 |
| Q1 | -6 |
| median | -3 |
| Q3 | 3 |
| 95-th percentile | 47 |
| Maximum | 3518 |
| Range | 3590 |
| Interquartile range (IQR) | 9 |
Descriptive statistics
| Standard deviation | 41.927209 |
|---|---|
| Coefficient of variation (CV) | 7.1380976 |
| Kurtosis | 539.72531 |
| Mean | 5.8737231 |
| Median Absolute Deviation (MAD) | 4 |
| Skewness | 16.520354 |
| Sum | 3306912 |
| Variance | 1757.8909 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| -5 | 47332 | 8.4% |
| -4 | 43658 | 7.7% |
| -3 | 41157 | 7.3% |
| -6 | 38620 | 6.9% |
| -2 | 36907 | 6.5% |
| -7 | 33511 | 5.9% |
| -1 | 32584 | 5.8% |
| 0 | 27141 | 4.8% |
| -8 | 26875 | 4.8% |
| -9 | 19751 | 3.5% |
| Other values (945) | 215465 |
| Value | Count | Frequency (%) |
| -72 | 1 | < 0.1% |
| -44 | 2 | |
| -43 | 1 | < 0.1% |
| -42 | 2 | |
| -41 | 1 | < 0.1% |
| -39 | 2 | |
| -38 | 1 | < 0.1% |
| -37 | 2 | |
| -36 | 4 | |
| -35 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 3518 | 1 | |
| 2939 | 1 | |
| 2454 | 1 | |
| 2432 | 1 | |
| 2379 | 1 | |
| 2344 | 1 | |
| 2306 | 1 | |
| 2295 | 1 | |
| 1935 | 1 | |
| 1909 | 1 |
TAXI_OUT
Real number (ℝ)
| Distinct | 138 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 801 |
| Missing (%) | 0.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 17.132189 |
| Minimum | 1 |
|---|---|
| Maximum | 269 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.3 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 9 |
| Q1 | 12 |
| median | 15 |
| Q3 | 20 |
| 95-th percentile | 32 |
| Maximum | 269 |
| Range | 268 |
| Interquartile range (IQR) | 8 |
Descriptive statistics
| Standard deviation | 8.1887769 |
|---|---|
| Coefficient of variation (CV) | 0.47797611 |
| Kurtosis | 16.058892 |
| Mean | 17.132189 |
| Median Absolute Deviation (MAD) | 4 |
| Skewness | 2.7057902 |
| Sum | 9645011 |
| Variance | 67.056068 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 13 | 46344 | 8.2% |
| 12 | 46257 | 8.2% |
| 14 | 43618 | 7.7% |
| 11 | 42331 | 7.5% |
| 15 | 40216 | 7.1% |
| 16 | 35471 | 6.3% |
| 10 | 34297 | 6.1% |
| 17 | 30801 | 5.5% |
| 18 | 26729 | 4.7% |
| 9 | 23235 | 4.1% |
| Other values (128) | 193677 |
| Value | Count | Frequency (%) |
| 1 | 21 | < 0.1% |
| 2 | 27 | < 0.1% |
| 3 | 52 | < 0.1% |
| 4 | 171 | < 0.1% |
| 5 | 519 | 0.1% |
| 6 | 2070 | 0.4% |
| 7 | 5860 | 1.0% |
| 8 | 12720 | 2.3% |
| 9 | 23235 | |
| 10 | 34297 |
| Value | Count | Frequency (%) |
| 269 | 1 | < 0.1% |
| 177 | 1 | < 0.1% |
| 162 | 1 | < 0.1% |
| 149 | 1 | < 0.1% |
| 143 | 1 | < 0.1% |
| 142 | 1 | < 0.1% |
| 141 | 3 | |
| 139 | 2 | |
| 138 | 1 | < 0.1% |
| 137 | 1 | < 0.1% |
TAXI_IN
Real number (ℝ)
| Distinct | 110 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 869 |
| Missing (%) | 0.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 7.858563 |
| Minimum | 1 |
|---|---|
| Maximum | 132 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.3 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 3 |
| Q1 | 4 |
| median | 6 |
| Q3 | 9 |
| 95-th percentile | 18 |
| Maximum | 132 |
| Range | 131 |
| Interquartile range (IQR) | 5 |
Descriptive statistics
| Standard deviation | 5.6667585 |
|---|---|
| Coefficient of variation (CV) | 0.72109348 |
| Kurtosis | 22.015745 |
| Mean | 7.858563 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | 3.387098 |
| Sum | 4423648 |
| Variance | 32.112152 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 4 | 85959 | |
| 5 | 81758 | |
| 6 | 67439 | |
| 7 | 54795 | |
| 3 | 48992 | |
| 8 | 42536 | |
| 9 | 33052 | 5.9% |
| 10 | 25786 | 4.6% |
| 11 | 19863 | 3.5% |
| 12 | 15811 | 2.8% |
| Other values (100) | 86917 |
| Value | Count | Frequency (%) |
| 1 | 717 | 0.1% |
| 2 | 11697 | 2.1% |
| 3 | 48992 | |
| 4 | 85959 | |
| 5 | 81758 | |
| 6 | 67439 | |
| 7 | 54795 | |
| 8 | 42536 | |
| 9 | 33052 | 5.9% |
| 10 | 25786 | 4.6% |
| Value | Count | Frequency (%) |
| 132 | 1 | |
| 131 | 1 | |
| 126 | 1 | |
| 125 | 1 | |
| 118 | 1 | |
| 115 | 1 | |
| 111 | 2 | |
| 107 | 1 | |
| 105 | 1 | |
| 104 | 2 |
CRS_ARR_TIME
Real number (ℝ)
| Distinct | 1396 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1488.1848 |
| Minimum | 1 |
|---|---|
| Maximum | 2359 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.3 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 720 |
| Q1 | 1100 |
| median | 1515 |
| Q3 | 1925 |
| 95-th percentile | 2259 |
| Maximum | 2359 |
| Range | 2358 |
| Interquartile range (IQR) | 825 |
Descriptive statistics
| Standard deviation | 523.64405 |
|---|---|
| Coefficient of variation (CV) | 0.35186761 |
| Kurtosis | -0.45728531 |
| Mean | 1488.1848 |
| Median Absolute Deviation (MAD) | 412 |
| Skewness | -0.29822599 |
| Sum | 8.3900439 × 108 |
| Variance | 274203.09 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 2359 | 2376 | 0.4% |
| 2200 | 2043 | 0.4% |
| 1400 | 1824 | 0.3% |
| 1810 | 1791 | 0.3% |
| 1855 | 1688 | 0.3% |
| 2000 | 1675 | 0.3% |
| 1005 | 1587 | 0.3% |
| 1500 | 1583 | 0.3% |
| 905 | 1566 | 0.3% |
| 2150 | 1564 | 0.3% |
| Other values (1386) | 546080 |
| Value | Count | Frequency (%) |
| 1 | 55 | < 0.1% |
| 2 | 107 | < 0.1% |
| 3 | 125 | < 0.1% |
| 4 | 210 | |
| 5 | 467 | |
| 6 | 220 | |
| 7 | 207 | |
| 8 | 92 | < 0.1% |
| 9 | 89 | < 0.1% |
| 10 | 487 |
| Value | Count | Frequency (%) |
| 2359 | 2376 | |
| 2358 | 783 | 0.1% |
| 2357 | 822 | 0.1% |
| 2356 | 651 | 0.1% |
| 2355 | 1195 | |
| 2354 | 518 | 0.1% |
| 2353 | 361 | 0.1% |
| 2352 | 531 | 0.1% |
| 2351 | 367 | 0.1% |
| 2350 | 764 | 0.1% |
ARR_TIME
Real number (ℝ)
| Distinct | 1440 |
|---|---|
| Distinct (%) | 0.3% |
| Missing | 869 |
| Missing (%) | 0.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1469.3344 |
| Minimum | 1 |
|---|---|
| Maximum | 2400 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.3 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 657 |
| Q1 | 1048 |
| median | 1506 |
| Q3 | 1919 |
| 95-th percentile | 2252 |
| Maximum | 2400 |
| Range | 2399 |
| Interquartile range (IQR) | 871 |
Descriptive statistics
| Standard deviation | 535.05867 |
|---|---|
| Coefficient of variation (CV) | 0.36415038 |
| Kurtosis | -0.42290291 |
| Mean | 1469.3344 |
| Median Absolute Deviation (MAD) | 424 |
| Skewness | -0.33420864 |
| Sum | 8.2710008 × 108 |
| Variance | 286287.78 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1638 | 654 | 0.1% |
| 1646 | 652 | 0.1% |
| 1857 | 651 | 0.1% |
| 1653 | 651 | 0.1% |
| 1637 | 640 | 0.1% |
| 1704 | 631 | 0.1% |
| 1647 | 630 | 0.1% |
| 1627 | 627 | 0.1% |
| 1626 | 625 | 0.1% |
| 2142 | 625 | 0.1% |
| Other values (1430) | 556522 | |
| (Missing) | 869 | 0.2% |
| Value | Count | Frequency (%) |
| 1 | 334 | |
| 2 | 281 | |
| 3 | 312 | |
| 4 | 295 | |
| 5 | 321 | |
| 6 | 278 | |
| 7 | 257 | |
| 8 | 298 | |
| 9 | 286 | |
| 10 | 267 |
| Value | Count | Frequency (%) |
| 2400 | 309 | |
| 2359 | 333 | |
| 2358 | 333 | |
| 2357 | 369 | |
| 2356 | 360 | |
| 2355 | 369 | |
| 2354 | 373 | |
| 2353 | 380 | |
| 2352 | 376 | |
| 2351 | 370 |
ARR_DELAY
Real number (ℝ)
ZEROS
| Distinct | 976 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 1364 |
| Missing (%) | 0.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | -1.2563383 |
| Minimum | -83 |
|---|---|
| Maximum | 3502 |
| Zeros | 10405 |
| Zeros (%) | 1.8% |
| Negative | 391748 |
| Negative (%) | 69.5% |
| Memory size | 4.3 MiB |
Quantile statistics
| Minimum | -83 |
|---|---|
| 5-th percentile | -29 |
| Q1 | -17 |
| median | -9 |
| Q3 | 3 |
| 95-th percentile | 44 |
| Maximum | 3502 |
| Range | 3585 |
| Interquartile range (IQR) | 20 |
Descriptive statistics
| Standard deviation | 43.52781 |
|---|---|
| Coefficient of variation (CV) | -34.646567 |
| Kurtosis | 467.43364 |
| Mean | -1.2563383 |
| Median Absolute Deviation (MAD) | 9 |
| Skewness | 14.802206 |
| Sum | -706581 |
| Variance | 1894.6702 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| -12 | 17300 | 3.1% |
| -10 | 17211 | 3.1% |
| -13 | 17091 | 3.0% |
| -14 | 16996 | 3.0% |
| -11 | 16946 | 3.0% |
| -9 | 16697 | 3.0% |
| -15 | 16483 | 2.9% |
| -8 | 16057 | 2.8% |
| -16 | 15727 | 2.8% |
| -7 | 15375 | 2.7% |
| Other values (966) | 396530 |
| Value | Count | Frequency (%) |
| -83 | 1 | < 0.1% |
| -76 | 1 | < 0.1% |
| -75 | 2 | < 0.1% |
| -73 | 1 | < 0.1% |
| -72 | 1 | < 0.1% |
| -71 | 2 | < 0.1% |
| -70 | 3 | |
| -69 | 4 | |
| -68 | 3 | |
| -67 | 5 |
| Value | Count | Frequency (%) |
| 3502 | 1 | |
| 2928 | 1 | |
| 2518 | 1 | |
| 2408 | 1 | |
| 2362 | 1 | |
| 2325 | 1 | |
| 2319 | 1 | |
| 2281 | 1 | |
| 1920 | 1 | |
| 1918 | 1 |
CANCELLED
Categorical
IMBALANCE
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.3 MiB |
| 0.0 | |
|---|---|
| 1.0 | 819 |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 1691331 |
|---|---|
| Distinct characters | 3 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0.0 |
|---|---|
| 2nd row | 0.0 |
| 3rd row | 0.0 |
| 4th row | 0.0 |
| 5th row | 0.0 |
Common Values
| Value | Count | Frequency (%) |
| 0.0 | 562958 | |
| 1.0 | 819 | 0.1% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0.0 | 562958 | |
| 1.0 | 819 | 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 1126735 | |
| . | 563777 | |
| 1 | 819 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1691331 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 1126735 | |
| . | 563777 | |
| 1 | 819 | < 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1691331 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 1126735 | |
| . | 563777 | |
| 1 | 819 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1691331 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 1126735 | |
| . | 563777 | |
| 1 | 819 | < 0.1% |
CANCELLATION_CODE
Categorical
MISSING
| Distinct | 3 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 562958 |
| Missing (%) | 99.9% |
| Memory size | 4.3 MiB |
| A | |
|---|---|
| B | |
| C | 39 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Characters and Unicode
| Total characters | 819 |
|---|---|
| Distinct characters | 3 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | A |
|---|---|
| 2nd row | A |
| 3rd row | A |
| 4th row | A |
| 5th row | A |
Common Values
| Value | Count | Frequency (%) |
| A | 522 | 0.1% |
| B | 258 | < 0.1% |
| C | 39 | < 0.1% |
| (Missing) | 562958 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| a | 522 | |
| b | 258 | |
| c | 39 | 4.8% |
Most occurring characters
| Value | Count | Frequency (%) |
| A | 522 | |
| B | 258 | |
| C | 39 | 4.8% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 819 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| A | 522 | |
| B | 258 | |
| C | 39 | 4.8% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 819 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| A | 522 | |
| B | 258 | |
| C | 39 | 4.8% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 819 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| A | 522 | |
| B | 258 | |
| C | 39 | 4.8% |
DIVERTED
Categorical
IMBALANCE
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 4.3 MiB |
| 0.0 | |
|---|---|
| 1.0 | 545 |
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 1691331 |
|---|---|
| Distinct characters | 3 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 0.0 |
|---|---|
| 2nd row | 0.0 |
| 3rd row | 0.0 |
| 4th row | 0.0 |
| 5th row | 0.0 |
Common Values
| Value | Count | Frequency (%) |
| 0.0 | 563232 | |
| 1.0 | 545 | 0.1% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0.0 | 563232 | |
| 1.0 | 545 | 0.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| 0 | 1127009 | |
| . | 563777 | |
| 1 | 545 | < 0.1% |
Most occurring categories
| Value | Count | Frequency (%) |
| (unknown) | 1691331 |
Most frequent character per category
(unknown)
| Value | Count | Frequency (%) |
| 0 | 1127009 | |
| . | 563777 | |
| 1 | 545 | < 0.1% |
Most occurring scripts
| Value | Count | Frequency (%) |
| (unknown) | 1691331 |
Most frequent character per script
(unknown)
| Value | Count | Frequency (%) |
| 0 | 1127009 | |
| . | 563777 | |
| 1 | 545 | < 0.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| (unknown) | 1691331 |
Most frequent character per block
(unknown)
| Value | Count | Frequency (%) |
| 0 | 1127009 | |
| . | 563777 | |
| 1 | 545 | < 0.1% |
AIR_TIME
Real number (ℝ)
| Distinct | 628 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 1364 |
| Missing (%) | 0.2% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 114.83977 |
| Minimum | 8 |
|---|---|
| Maximum | 690 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.3 MiB |
Quantile statistics
| Minimum | 8 |
|---|---|
| 5-th percentile | 36 |
| Q1 | 63 |
| median | 98 |
| Q3 | 144 |
| 95-th percentile | 267 |
| Maximum | 690 |
| Range | 682 |
| Interquartile range (IQR) | 81 |
Descriptive statistics
| Standard deviation | 70.308165 |
|---|---|
| Coefficient of variation (CV) | 0.61222836 |
| Kurtosis | 2.654434 |
| Mean | 114.83977 |
| Median Absolute Deviation (MAD) | 39 |
| Skewness | 1.4374634 |
| Sum | 64587381 |
| Variance | 4943.2381 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 55 | 4747 | 0.8% |
| 58 | 4677 | 0.8% |
| 63 | 4650 | 0.8% |
| 64 | 4647 | 0.8% |
| 59 | 4621 | 0.8% |
| 66 | 4617 | 0.8% |
| 67 | 4607 | 0.8% |
| 65 | 4604 | 0.8% |
| 60 | 4601 | 0.8% |
| 62 | 4580 | 0.8% |
| Other values (618) | 516062 |
| Value | Count | Frequency (%) |
| 8 | 3 | < 0.1% |
| 9 | 21 | < 0.1% |
| 10 | 15 | < 0.1% |
| 11 | 3 | < 0.1% |
| 12 | 3 | < 0.1% |
| 13 | 1 | < 0.1% |
| 14 | 9 | < 0.1% |
| 15 | 38 | < 0.1% |
| 16 | 86 | |
| 17 | 171 |
| Value | Count | Frequency (%) |
| 690 | 1 | |
| 682 | 1 | |
| 664 | 2 | |
| 663 | 1 | |
| 659 | 1 | |
| 658 | 1 | |
| 657 | 1 | |
| 656 | 2 | |
| 654 | 2 | |
| 652 | 2 |
CARRIER_DELAY
Real number (ℝ)
MISSING ZEROS
| Distinct | 752 |
|---|---|
| Distinct (%) | 1.0% |
| Missing | 487430 |
| Missing (%) | 86.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 25.206112 |
| Minimum | 0 |
|---|---|
| Maximum | 3502 |
| Zeros | 31823 |
| Zeros (%) | 5.6% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.3 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 5 |
| Q3 | 23 |
| 95-th percentile | 102 |
| Maximum | 3502 |
| Range | 3502 |
| Interquartile range (IQR) | 23 |
Descriptive statistics
| Standard deviation | 77.057629 |
|---|---|
| Coefficient of variation (CV) | 3.057101 |
| Kurtosis | 233.68573 |
| Mean | 25.206112 |
| Median Absolute Deviation (MAD) | 5 |
| Skewness | 11.626472 |
| Sum | 1924411 |
| Variance | 5937.8781 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 31823 | 5.6% |
| 1 | 1564 | 0.3% |
| 2 | 1496 | 0.3% |
| 3 | 1469 | 0.3% |
| 6 | 1417 | 0.3% |
| 4 | 1398 | 0.2% |
| 15 | 1386 | 0.2% |
| 7 | 1357 | 0.2% |
| 5 | 1273 | 0.2% |
| 16 | 1242 | 0.2% |
| Other values (742) | 31922 | 5.7% |
| (Missing) | 487430 |
| Value | Count | Frequency (%) |
| 0 | 31823 | |
| 1 | 1564 | 0.3% |
| 2 | 1496 | 0.3% |
| 3 | 1469 | 0.3% |
| 4 | 1398 | 0.2% |
| 5 | 1273 | 0.2% |
| 6 | 1417 | 0.3% |
| 7 | 1357 | 0.2% |
| 8 | 1234 | 0.2% |
| 9 | 1215 | 0.2% |
| Value | Count | Frequency (%) |
| 3502 | 1 | |
| 2928 | 1 | |
| 2454 | 1 | |
| 2408 | 1 | |
| 2362 | 1 | |
| 2241 | 1 | |
| 1891 | 1 | |
| 1838 | 1 | |
| 1795 | 1 | |
| 1730 | 1 |
WEATHER_DELAY
Real number (ℝ)
MISSING SKEWED ZEROS
| Distinct | 343 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 487430 |
| Missing (%) | 86.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2.2251562 |
| Minimum | 0 |
|---|---|
| Maximum | 1860 |
| Zeros | 73995 |
| Zeros (%) | 13.1% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.3 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 1860 |
| Range | 1860 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 27.242073 |
|---|---|
| Coefficient of variation (CV) | 12.242769 |
| Kurtosis | 979.58982 |
| Mean | 2.2251562 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 26.307175 |
| Sum | 169884 |
| Variance | 742.13053 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 73995 | 13.1% |
| 10 | 66 | < 0.1% |
| 7 | 57 | < 0.1% |
| 15 | 56 | < 0.1% |
| 16 | 51 | < 0.1% |
| 8 | 51 | < 0.1% |
| 6 | 50 | < 0.1% |
| 4 | 49 | < 0.1% |
| 17 | 47 | < 0.1% |
| 2 | 47 | < 0.1% |
| Other values (333) | 1878 | 0.3% |
| (Missing) | 487430 |
| Value | Count | Frequency (%) |
| 0 | 73995 | |
| 1 | 46 | < 0.1% |
| 2 | 47 | < 0.1% |
| 3 | 45 | < 0.1% |
| 4 | 49 | < 0.1% |
| 5 | 40 | < 0.1% |
| 6 | 50 | < 0.1% |
| 7 | 57 | < 0.1% |
| 8 | 51 | < 0.1% |
| 9 | 45 | < 0.1% |
| Value | Count | Frequency (%) |
| 1860 | 1 | |
| 1488 | 1 | |
| 1483 | 1 | |
| 1018 | 1 | |
| 1014 | 1 | |
| 953 | 2 | |
| 941 | 1 | |
| 934 | 1 | |
| 913 | 1 | |
| 905 | 1 |
NAS_DELAY
Real number (ℝ)
MISSING ZEROS
| Distinct | 268 |
|---|---|
| Distinct (%) | 0.4% |
| Missing | 487430 |
| Missing (%) | 86.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 9.605551 |
| Minimum | 0 |
|---|---|
| Maximum | 1263 |
| Zeros | 38489 |
| Zeros (%) | 6.8% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.3 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 15 |
| 95-th percentile | 37 |
| Maximum | 1263 |
| Range | 1263 |
| Interquartile range (IQR) | 15 |
Descriptive statistics
| Standard deviation | 20.89399 |
|---|---|
| Coefficient of variation (CV) | 2.1751995 |
| Kurtosis | 447.19533 |
| Mean | 9.605551 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 13.486835 |
| Sum | 733355 |
| Variance | 436.5588 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 38489 | 6.8% |
| 1 | 2524 | 0.4% |
| 15 | 1869 | 0.3% |
| 16 | 1597 | 0.3% |
| 2 | 1537 | 0.3% |
| 17 | 1499 | 0.3% |
| 3 | 1482 | 0.3% |
| 4 | 1402 | 0.2% |
| 18 | 1335 | 0.2% |
| 5 | 1322 | 0.2% |
| Other values (258) | 23291 | 4.1% |
| (Missing) | 487430 |
| Value | Count | Frequency (%) |
| 0 | 38489 | |
| 1 | 2524 | 0.4% |
| 2 | 1537 | 0.3% |
| 3 | 1482 | 0.3% |
| 4 | 1402 | 0.2% |
| 5 | 1322 | 0.2% |
| 6 | 1221 | 0.2% |
| 7 | 1180 | 0.2% |
| 8 | 1122 | 0.2% |
| 9 | 1061 | 0.2% |
| Value | Count | Frequency (%) |
| 1263 | 1 | |
| 950 | 1 | |
| 903 | 1 | |
| 785 | 1 | |
| 719 | 2 | |
| 677 | 1 | |
| 652 | 1 | |
| 634 | 1 | |
| 590 | 1 | |
| 584 | 1 |
SECURITY_DELAY
Real number (ℝ)
MISSING SKEWED ZEROS
| Distinct | 84 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 487430 |
| Missing (%) | 86.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.17798997 |
| Minimum | 0 |
|---|---|
| Maximum | 234 |
| Zeros | 75722 |
| Zeros (%) | 13.4% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.3 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 0 |
| 95-th percentile | 0 |
| Maximum | 234 |
| Range | 234 |
| Interquartile range (IQR) | 0 |
Descriptive statistics
| Standard deviation | 2.7023469 |
|---|---|
| Coefficient of variation (CV) | 15.18258 |
| Kurtosis | 1299.1604 |
| Mean | 0.17798997 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 28.019224 |
| Sum | 13589 |
| Variance | 7.3026785 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 75722 | 13.4% |
| 15 | 33 | < 0.1% |
| 9 | 31 | < 0.1% |
| 20 | 31 | < 0.1% |
| 16 | 23 | < 0.1% |
| 21 | 22 | < 0.1% |
| 10 | 22 | < 0.1% |
| 8 | 21 | < 0.1% |
| 2 | 20 | < 0.1% |
| 19 | 19 | < 0.1% |
| Other values (74) | 403 | 0.1% |
| (Missing) | 487430 |
| Value | Count | Frequency (%) |
| 0 | 75722 | |
| 1 | 13 | < 0.1% |
| 2 | 20 | < 0.1% |
| 3 | 16 | < 0.1% |
| 4 | 12 | < 0.1% |
| 5 | 16 | < 0.1% |
| 6 | 15 | < 0.1% |
| 7 | 16 | < 0.1% |
| 8 | 21 | < 0.1% |
| 9 | 31 | < 0.1% |
| Value | Count | Frequency (%) |
| 234 | 1 | |
| 134 | 1 | |
| 124 | 1 | |
| 114 | 1 | |
| 110 | 1 | |
| 101 | 1 | |
| 98 | 1 | |
| 97 | 1 | |
| 96 | 1 | |
| 92 | 1 |
LATE_AIRCRAFT_DELAY
Real number (ℝ)
MISSING ZEROS
| Distinct | 556 |
|---|---|
| Distinct (%) | 0.7% |
| Missing | 487430 |
| Missing (%) | 86.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 22.149292 |
| Minimum | 0 |
|---|---|
| Maximum | 2325 |
| Zeros | 40437 |
| Zeros (%) | 7.2% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 4.3 MiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0 |
| Q3 | 25 |
| 95-th percentile | 99 |
| Maximum | 2325 |
| Range | 2325 |
| Interquartile range (IQR) | 25 |
Descriptive statistics
| Standard deviation | 55.034199 |
|---|---|
| Coefficient of variation (CV) | 2.4846933 |
| Kurtosis | 203.34907 |
| Mean | 22.149292 |
| Median Absolute Deviation (MAD) | 0 |
| Skewness | 9.9025622 |
| Sum | 1691032 |
| Variance | 3028.763 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 0 | 40437 | 7.2% |
| 16 | 1038 | 0.2% |
| 15 | 1033 | 0.2% |
| 17 | 946 | 0.2% |
| 18 | 920 | 0.2% |
| 20 | 840 | 0.1% |
| 19 | 805 | 0.1% |
| 21 | 743 | 0.1% |
| 14 | 741 | 0.1% |
| 13 | 695 | 0.1% |
| Other values (546) | 28149 | 5.0% |
| (Missing) | 487430 |
| Value | Count | Frequency (%) |
| 0 | 40437 | |
| 1 | 522 | 0.1% |
| 2 | 524 | 0.1% |
| 3 | 481 | 0.1% |
| 4 | 530 | 0.1% |
| 5 | 536 | 0.1% |
| 6 | 623 | 0.1% |
| 7 | 607 | 0.1% |
| 8 | 571 | 0.1% |
| 9 | 615 | 0.1% |
| Value | Count | Frequency (%) |
| 2325 | 1 | |
| 2277 | 1 | |
| 1880 | 1 | |
| 1695 | 1 | |
| 1656 | 1 | |
| 1388 | 1 | |
| 1295 | 1 | |
| 1234 | 1 | |
| 1217 | 1 | |
| 1201 | 1 |
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
| DAY_OF_WEEK | FL_DATE | OP_UNIQUE_CARRIER | OP_CARRIER_FL_NUM | ORIGIN_AIRPORT_ID | ORIGIN | ORIGIN_CITY_NAME | ORIGIN_STATE_NM | ORIGIN_WAC | DEST_AIRPORT_ID | DEST | DEST_CITY_NAME | DEST_STATE_NM | DEST_WAC | CRS_DEP_TIME | DEP_TIME | DEP_DELAY | TAXI_OUT | TAXI_IN | CRS_ARR_TIME | ARR_TIME | ARR_DELAY | CANCELLED | CANCELLATION_CODE | DIVERTED | AIR_TIME | CARRIER_DELAY | WEATHER_DELAY | NAS_DELAY | SECURITY_DELAY | LATE_AIRCRAFT_DELAY | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 1 | 11/6/2023 12:00:00 AM | 9E | 4800 | 12953 | LGA | New York, NY | New York | 22 | 15016 | STL | St. Louis, MO | Missouri | 64 | 1846 | 1838.0 | -8.0 | 33.0 | 6.0 | 2046 | 2035.0 | -11.0 | 0.0 | NaN | 0.0 | 138.0 | NaN | NaN | NaN | NaN | NaN |
| 1 | 1 | 11/6/2023 12:00:00 AM | 9E | 4803 | 12953 | LGA | New York, NY | New York | 22 | 15096 | SYR | Syracuse, NY | New York | 22 | 2152 | 2142.0 | -10.0 | 17.0 | 6.0 | 2303 | 2250.0 | -13.0 | 0.0 | NaN | 0.0 | 45.0 | NaN | NaN | NaN | NaN | NaN |
| 2 | 1 | 11/6/2023 12:00:00 AM | 9E | 4804 | 15412 | TYS | Knoxville, TN | Tennessee | 54 | 12953 | LGA | New York, NY | New York | 22 | 619 | 614.0 | -5.0 | 13.0 | 7.0 | 829 | 801.0 | -28.0 | 0.0 | NaN | 0.0 | 87.0 | NaN | NaN | NaN | NaN | NaN |
| 3 | 1 | 11/6/2023 12:00:00 AM | 9E | 4805 | 12953 | LGA | New York, NY | New York | 22 | 15412 | TYS | Knoxville, TN | Tennessee | 54 | 1800 | 1752.0 | -8.0 | 13.0 | 4.0 | 2028 | 1955.0 | -33.0 | 0.0 | NaN | 0.0 | 106.0 | NaN | NaN | NaN | NaN | NaN |
| 4 | 1 | 11/6/2023 12:00:00 AM | 9E | 4807 | 12478 | JFK | New York, NY | New York | 22 | 13931 | ORF | Norfolk, VA | Virginia | 38 | 1940 | 1934.0 | -6.0 | 42.0 | 6.0 | 2121 | 2123.0 | 2.0 | 0.0 | NaN | 0.0 | 61.0 | NaN | NaN | NaN | NaN | NaN |
| 5 | 1 | 11/6/2023 12:00:00 AM | 9E | 4808 | 12953 | LGA | New York, NY | New York | 22 | 13931 | ORF | Norfolk, VA | Virginia | 38 | 1529 | 1520.0 | -9.0 | 27.0 | 5.0 | 1709 | 1647.0 | -22.0 | 0.0 | NaN | 0.0 | 55.0 | NaN | NaN | NaN | NaN | NaN |
| 6 | 1 | 11/6/2023 12:00:00 AM | 9E | 4808 | 13931 | ORF | Norfolk, VA | Virginia | 38 | 12953 | LGA | New York, NY | New York | 22 | 1815 | 1806.0 | -9.0 | 51.0 | 11.0 | 1957 | 2005.0 | 8.0 | 0.0 | NaN | 0.0 | 57.0 | NaN | NaN | NaN | NaN | NaN |
| 7 | 1 | 11/6/2023 12:00:00 AM | 9E | 4811 | 13198 | MCI | Kansas City, MO | Missouri | 64 | 12478 | JFK | New York, NY | New York | 22 | 704 | 657.0 | -7.0 | 17.0 | 18.0 | 1059 | 1044.0 | -15.0 | 0.0 | NaN | 0.0 | 132.0 | NaN | NaN | NaN | NaN | NaN |
| 8 | 1 | 11/6/2023 12:00:00 AM | 9E | 4812 | 12953 | LGA | New York, NY | New York | 22 | 13577 | MYR | Myrtle Beach, SC | South Carolina | 37 | 2040 | 2031.0 | -9.0 | 16.0 | 4.0 | 2254 | 2212.0 | -42.0 | 0.0 | NaN | 0.0 | 81.0 | NaN | NaN | NaN | NaN | NaN |
| 9 | 1 | 11/6/2023 12:00:00 AM | 9E | 4813 | 12478 | JFK | New York, NY | New York | 22 | 13931 | ORF | Norfolk, VA | Virginia | 38 | 1340 | 1335.0 | -5.0 | 22.0 | 5.0 | 1510 | 1502.0 | -8.0 | 0.0 | NaN | 0.0 | 60.0 | NaN | NaN | NaN | NaN | NaN |
| DAY_OF_WEEK | FL_DATE | OP_UNIQUE_CARRIER | OP_CARRIER_FL_NUM | ORIGIN_AIRPORT_ID | ORIGIN | ORIGIN_CITY_NAME | ORIGIN_STATE_NM | ORIGIN_WAC | DEST_AIRPORT_ID | DEST | DEST_CITY_NAME | DEST_STATE_NM | DEST_WAC | CRS_DEP_TIME | DEP_TIME | DEP_DELAY | TAXI_OUT | TAXI_IN | CRS_ARR_TIME | ARR_TIME | ARR_DELAY | CANCELLED | CANCELLATION_CODE | DIVERTED | AIR_TIME | CARRIER_DELAY | WEATHER_DELAY | NAS_DELAY | SECURITY_DELAY | LATE_AIRCRAFT_DELAY | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 563767 | 7 | 11/26/2023 12:00:00 AM | YX | 5837 | 10721 | BOS | Boston, MA | Massachusetts | 13 | 11278 | DCA | Washington, DC | Virginia | 38 | 855 | 905.0 | 10.0 | 17.0 | 3.0 | 1100 | 1044.0 | -16.0 | 0.0 | NaN | 0.0 | 79.0 | NaN | NaN | NaN | NaN | NaN |
| 563768 | 7 | 11/26/2023 12:00:00 AM | YX | 5838 | 10721 | BOS | Boston, MA | Massachusetts | 13 | 14524 | RIC | Richmond, VA | Virginia | 38 | 1510 | 1504.0 | -6.0 | 21.0 | 8.0 | 1708 | 1701.0 | -7.0 | 0.0 | NaN | 0.0 | 88.0 | NaN | NaN | NaN | NaN | NaN |
| 563769 | 7 | 11/26/2023 12:00:00 AM | YX | 5838 | 14524 | RIC | Richmond, VA | Virginia | 38 | 10721 | BOS | Boston, MA | Massachusetts | 13 | 1756 | 1749.0 | -7.0 | 10.0 | 9.0 | 1944 | 1917.0 | -27.0 | 0.0 | NaN | 0.0 | 69.0 | NaN | NaN | NaN | NaN | NaN |
| 563770 | 7 | 11/26/2023 12:00:00 AM | YX | 5842 | 10721 | BOS | Boston, MA | Massachusetts | 13 | 11066 | CMH | Columbus, OH | Ohio | 44 | 1350 | 1342.0 | -8.0 | 19.0 | 6.0 | 1611 | 1608.0 | -3.0 | 0.0 | NaN | 0.0 | 121.0 | NaN | NaN | NaN | NaN | NaN |
| 563771 | 7 | 11/26/2023 12:00:00 AM | YX | 5844 | 14492 | RDU | Raleigh/Durham, NC | North Carolina | 36 | 12953 | LGA | New York, NY | New York | 22 | 600 | 557.0 | -3.0 | 17.0 | 21.0 | 751 | 733.0 | -18.0 | 0.0 | NaN | 0.0 | 58.0 | NaN | NaN | NaN | NaN | NaN |
| 563772 | 7 | 11/26/2023 12:00:00 AM | YX | 5845 | 10721 | BOS | Boston, MA | Massachusetts | 13 | 12953 | LGA | New York, NY | New York | 22 | 1900 | 1855.0 | -5.0 | 31.0 | 10.0 | 2037 | 2052.0 | 15.0 | 0.0 | NaN | 0.0 | 76.0 | 0.0 | 0.0 | 15.0 | 0.0 | 0.0 |
| 563773 | 7 | 11/26/2023 12:00:00 AM | YX | 5847 | 12339 | IND | Indianapolis, IN | Indiana | 42 | 12953 | LGA | New York, NY | New York | 22 | 1515 | 1508.0 | -7.0 | 10.0 | 9.0 | 1724 | 1654.0 | -30.0 | 0.0 | NaN | 0.0 | 87.0 | NaN | NaN | NaN | NaN | NaN |
| 563774 | 7 | 11/26/2023 12:00:00 AM | YX | 5848 | 11066 | CMH | Columbus, OH | Ohio | 44 | 10721 | BOS | Boston, MA | Massachusetts | 13 | 1206 | 1200.0 | -6.0 | 13.0 | 9.0 | 1403 | 1353.0 | -10.0 | 0.0 | NaN | 0.0 | 91.0 | NaN | NaN | NaN | NaN | NaN |
| 563775 | 7 | 11/26/2023 12:00:00 AM | YX | 5849 | 11278 | DCA | Washington, DC | Virginia | 38 | 10721 | BOS | Boston, MA | Massachusetts | 13 | 1700 | 1659.0 | -1.0 | 12.0 | 11.0 | 1851 | 1827.0 | -24.0 | 0.0 | NaN | 0.0 | 65.0 | NaN | NaN | NaN | NaN | NaN |
| 563776 | 7 | 11/26/2023 12:00:00 AM | YX | 5850 | 11278 | DCA | Washington, DC | Virginia | 38 | 10721 | BOS | Boston, MA | Massachusetts | 13 | 1150 | 1142.0 | -8.0 | 12.0 | 21.0 | 1332 | 1319.0 | -13.0 | 0.0 | NaN | 0.0 | 64.0 | NaN | NaN | NaN | NaN | NaN |